#!/usr/bin/env python
#-*-coding:utf-8-*- 
__author__ = 'Mzx'


from models import region_retailsales,shop_level
from sqlalchemy import desc



# for i in region_retailsales.query.order_by(desc(region_retailsales._retailSales)).all():
k = region_retailsales.query.order_by(desc(region_retailsales._retailSales)).all()
local = {}
for i in k:
    local[i._region] = i._retailSales

for i in k[-1:]:
    local[i._region] = i._retailSales

for i in range(0,10):
    print(i)
# print(local)